Copy and paste from the following data to produce each assessment task. Write these in plain English and spell out how, when and where the task is to be carried out, under what conditions, and what resources are needed. Include guidelines about how well the candidate has to perform a task for it to be judged satisfactory.
Required skills
analytical skills to:
evaluate interdependencies between data fields
examine and define system requirements for data
review requirements and determine the availability of information
communication skills to:
interact with developer to determine data requirement
interact with end user personnel to determine data requirement
liaise with management on report and result matters
literacy skills to:
read and interpret specifications developed by business and technical experts
write a report
problem-solving skills to:
address common issues relating to the operation of a computer system
perform basic troubleshooting to diagnose system problems
technical skills to:
perform basic data-management operations, such as insert, update and delete operations
perform basic operations of a computer system.
Required knowledge
basic knowledge of:
database design
desktop operating systems
relational databases
computer hardware and components
computer networking and components
structured query language (SQL).
The range statement relates to the unit of competency as a whole. It allows for different work environments and situations that may affect performance. Bold italicised wording, if used in the performance criteria, is detailed below. Essential operating conditions that may be present with training and assessment (depending on the work situation, needs of the candidate, accessibility of the item, and local industry and regional contexts) may also be included.
Components may include: | memory structure relational database management system (RDBMS) software stored procedures table structure. |
Database may include: | MS Access MySQL Oracle structured query language (SQL) server. |
Tools may include: | MySQL Workbench Oracle Enterprise Manager Database Control phpMyAdmin SQL Server Management Studio. |
Data-management tasks may include: | implement data compressions import and export data maintain indexes manage collations manage data partitions. |
Permissions may include: | implied object statement. |
Roles may include: | application database: fixed public defined server, such as fixed-server roles. |
Backups may include: | compressed differential file full database online and offline database transaction log. |
Recovery may include: | bulk-logged full simple. |
Optimisation may include: | cache mechanism data compression indexing. |
Copy and paste from the following performance criteria to create an observation checklist for each task. When you have finished writing your assessment tool every one of these must have been addressed, preferably several times in a variety of contexts. To ensure this occurs download the assessment matrix for the unit; enter each assessment task as a column header and place check marks against each performance criteria that task addresses.
Observation Checklist